Printing a Settlement Report

Once you have generated a Settlement Report, command options will appear allowing you to print or choose from a set of other print options.

The following displays on the Settlement Report:

Header

• The company name, based on the Net•Yield user registration information
• The purchase order number
• The received date
• The header note
• The vendor name and contact

Item Lot Detail

• Item Name – The name of the item.
• For each lot received:
  • Lot Number – The location or warehouse ID if lotted, followed by the lot number.
  • COOL – The COOL identity, if the item or lot has been assigned a COOL identity
  • Item Info – The item info lot attributes of the item received based on the Received Purchase Order settings
  • Received Quantity – The quantity received in the invoicing unit of measure and the invoicing unit of measure.
  • Product Cost – The per unit purchase cost in the invoicing unit of measure for the item, LB or EA
  • Other Cost – The purchase order add-on charges in the invoicing unit of measure for the item
  • Total Cost – The total purchase cost in the invoicing unit of measure for the item.
  • Product Price – The net product selling price in the invoicing unit of measure for the item. Sales credits display as negative
  • Ordered – The total quantity weight shipped.
  • Profit – The gross profit dollar amount
  • Cust – The customer ship-to ID code for the sales order. For inventory transfers a transfer number is shown in this field.
  • Order Number – The order number on which this lot was shipped. For inventory transfers, a date is shown in this column.
  • Order Status – The status of the order
    • I – Invoice
    • R – Ready
    • S – Shipped
    • P – Priced
    • O – Open
    • C - Credit Invoice
    • RTN - Indicates that a credit invoice was added back or returned to inventory

Item Summary

The following summary information is displayed for each item in the invoicing unit of measure. A grand total for each field below will also display at the end of the report. if the Shipped , Ordered or available quantities are zero, they will not appear on the report

• Total Sales – The total weight received in the invoicing unit of measure, if all the weight has been sold ,
• The average "Other" selling price of the item
• The total "Other" selling price in dollars for the item
• The average product selling price of the item
• Total product amount invoiced in dollars for the item
• Total Gross Profit Dollars for all invoices, shipped and ordered quantities
• Shipped – The total weight shipped on sales order and percentage of the total received shipped
• The average "Other" selling price for the quantity shipped
• The total "Other" selling price in dollars for the quantity shipped
• The average product selling price for the quantity shipped
• Total product sales dollars of the quantity shipped
• Ordered – The total weight on unshipped sales order and percentage of the total received ordered
• The average "Other" selling price for the quantity ordered
• The total "Other" selling price in dollars for the quantity ordered
• The average product selling price for the quantity Ordered
• Total product sales dollars of the quantity shipped

• Available – The total weight on available

The following information displays on the Vendor Copy of the Settlement Report:

Header

• The company name, based on the Net•Yield user registration information.
• The purchase order number
• The received date
• The purchase order header description
• The vendor name and contact

Item Detail

• Item Name – The name of the item
• For each lot received:
  • Lot Number - The location or warehouse ID if lotted, followed by the lot the number.
  • COOL – The COOL identity if the item or lot has been assigned a COOL identifier
  • Item info – The item info lot attributes of the lot received
  • Received Quantity – The quantity received, in the invoicing unit of measure and the unit of measure LB or EA
  • Cost – The per unit cost of the item received in the invoicing unit of measure.
  • Extended Cost – The total cost of the item
  • The total weight received, total line count, and the cost of the item.
• Grand total of all items received; the total weight received and total cost.

For more information on the Settlement Report see Settlement Report.

Security Required : Purchasing - Purchasing Reports